package com.example.mybatisplus.mapper;

import com.example.mybatisplus.model.domain.Attribute;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author lxp
 * @since 2025-03-11
 */
public interface AttributeMapper extends BaseMapper<Attribute> {
    @Select("SELECT proportion FROM attribute WHERE attribute = 'FreeWiFi'")
    Double getWifi();
    @Select("SELECT proportion FROM attribute WHERE attribute = 'BusinessAcceptsCreditCards'")
    Double getCredit();
    @Select("SELECT proportion FROM attribute WHERE attribute = 'GoodForKids'")
    Double getKid();
    @Select("SELECT proportion FROM attribute WHERE attribute = 'WheelchairAccessible'")
    Double getWheel();
    @Select("SELECT proportion FROM attribute WHERE attribute = 'RestaurantsGoodForGroups'")
    Double getGroup();
}
